package com.example.novelstory.dao.dxy;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.novelstory.entity.Advert;
import org.apache.ibatis.annotations.Mapper;

@Mapper//Dao层的注解

public interface AdvertDao extends BaseMapper<Advert> {
//    @Select("select * from advert")
//    public List<Advert> findadvertAll();
//
//    @Insert("INSERT INTO advert(advertid,advertname,advertlink) VALUES(#{advertid,jdbcType=VARCHAR},#{advertname,jdbcType=VARCHAR},#{advertlink,jdbcType=VARCHAR})")
//    public int addadvertInfo(@Param("advertid") int advertid, @Param("advertname") String advertname, @Param("advertlink") String advertlink);
//
//    @Delete("DELETE FROM advert WHERE id=#{advertid,jdbcType=VARCHAR}")
//    public int deleteadvertInfo(int advertid);
//
//    @Update("UPDATE advert SET advertname=#{advertname,jdbcType=VARCHAR},advertlink=#{advertlink,jdbcType=VARCHAR} WHERE advertid=#{advertid,jdbcType=VARCHAR}")
//    public int updeteadvertInfo(@Param("advertid") int advertid, @Param("advertname") String advertname, @Param("advertlink") String advertlink);

}
